package com.dao;

import com.mypg.News;
import com.mypg.Video;
import org.apache.ibatis.annotations.Param;

import java.sql.Timestamp;
import java.util.List;

public interface VideoDao {
    List<Video> selectAllVideo();
    Video selectVideoByVideo_id(int video_id);
    List<Video> selectVideoFor_video_table_jsp(@Param("video_class")String video_class, @Param("video_class_sub")String video_class_sub,
                                            @Param("start_row")int start_row, @Param("page_nums")int page_nums);
    int selectVideo_count_For_video_table_jsp(@Param("video_class")String video_class,
                                            @Param("video_class_sub")String video_class_sub);
    List<Video> selectVideoByVideo_class_sub(String video_class_sub);
    int selectVideo_count();

    void insertVideo(Video video);

    void deleteVideoByVideo_id(int video_id);

    void updateVideoByVideo_id(Video video);
    void updateVideo_imgByVideo_id(@Param("video_img")String video_img,@Param("video_id")int video_id);
}
